qbfdetl.pos-trn

Temporary Point of Sale Header


Table details

Area FinData
Dumpname transact
Label Temporary Point of Sale Header
Val.exp ?
Val.msg

Fields

Order Field Name x Label Datatype Format Initial Mand Description
60 acct-no X Acct character xxxxxx-xx-x
80 addr X Address character [2] x(24)
150 agri-bonus-no X Agri Bonus No character x(10)
100 city X City character x(24)
140 cust-ord-no X Cust Order character x(12)
160 id-no X Id No character x(13)
70 inv-name X Invoice Name character x(30)
200 lsc-card-no X Card No integer 999 0
190 mem-no X Member No integer 9999999 0
120 pay-type X Payment Type logical Tender/Acct True
110 post-cde X Postal Code character 9999
50 prc-cat X Price Category character !
130 ref-inv-no X Ref Invoice No character x(12)
170 sls-rep X Sales Rep character x(3)
90 suburb X Suburb character x(24)
180 tab-no X Table No character x(30) 0
10 till-ses X Till Session decimal-0 9999999999 0
40 trn-date X Transaction date date 99/99/9999 ?
20 trn-no X Trans No integer 999 0
30 trn-type X Transaction Type character !

Indexes

Index name Flags Fields Datatype
till-ses-trn P U till-ses (+) decimal
    trn-no (+) integer
+ = Ascending - = Descending P = Primary U = Unique I = Inactive W = Wordindex

Related tables

Parent tables
acr-clntacct   lsc-member   pos-savetrn   sys-town   sys-trntype  
Child tables
pos-quote   pos-salecomment   pos-savetrn   pos-sup-intv  


generated 24-6-2026 08:43