PA Billing Header HIST (PA33100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA33100

Product: Project Accounting (258)
Series: Project

Display Name: PA Billing Header HIST
Physical Name: PA33100
Technical Name: PA_Billing_HDR_HIST

Group Display Name: PA Billing Transactions History
Group Technical Name: PA Billing Transactions History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	PABILLTRXT	PA Biller Trx Type	PA_DDL_Biller_Trx_Type	Integer	2	0
2	PADocnumber20	PA Document No.	STR17_LBAU	String	18	17
3	NOTEINDX	Note Index	DLR14	Currency	10	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['PA Billing Header HIST'].NOTEINDX AS 'PA Billing Header HIST-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['PA Billing Header HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX
4	PADOCDT	PA Document Date	PA_Date	Date	4	8
5	PAPD	PA Post Date	PA_Date	Date	4	8
6	BACHNUMB	Batch Number	STR15_LBAU	String	16	15
7	BCHSOURC	Batch Source	STR15	String	16	15
8	TRXSORCE	TRX Source	STR13	String	14	13
9	PAuserid	PA User ID	STR15_User_ID	String	16	15
10	LSTEDTDT	Last Edit Date	DT_Date	Date	4	6
11	LSTUSRED	Last User to Edit	STR15	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PA Billing Header HIST'].LSTUSRED AS 'PA Billing Header HIST-Last User to Edit' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PA Billing Header HIST'].LSTUSRED = ['Users Master'].USERID
12	PAREFNO	PA Reference Document No.	STR17_LBAU	String	18	17
13	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	16	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['PA Billing Header HIST'].CUSTNMBR AS 'PA Billing Header HIST-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['PA Billing Header HIST'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
14	CSTPONBR	Customer PO Number	STR20_Document_Number	String	22	20
15	PRBTADCD	Primary Billto Address Code	STR15_LBAU	String	16	15
16	PYMTRMID	Payment Terms ID	STR20_Payment_Terms_ID	String	22	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['PA Billing Header HIST'].PYMTRMID AS 'PA Billing Header HIST-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['PA Billing Header HIST'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
17	PABILLFORMAT	PA Bill Format	STR15_LBAU	String	16	15
18	PACOMM	PA Comment	STR50	String	52	50
19	CURNCYID	Currency ID	STR15_Currency_ID	String	16	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PA Billing Header HIST'].CURNCYID AS 'PA Billing Header HIST-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PA Billing Header HIST'].CURNCYID = ['Currency Setup'].CURNCYID
20	PAUD1	PA User Defined 1	STR20	String	22	20
21	PAUD2	PA User Defined 2	STR20	String	22	20
22	CASHAMNT	Cash Amount	DLR19_RBS0_UTR$	Currency	10	19
23	CBKIDCSH	Checkbook ID Cash	STR15_Checkbook_ID	String	16	15
24	CASHDATE	Cash Date	DATE	Date	4	6
25	DCNUMCSH	Document Number Cash	STR20_Document_Number	String	22	20
26	CHEKAMNT	Check Amount	DLR19_RBS0_UTR$	Currency	10	19
27	CBKIDCHK	Checkbook ID Check	STR15_Checkbook_ID	String	16	15
28	CHEKNMBR	Check Number	STR20_Document_Number	String	22	20
29	CHEKDATE	Check Date	DATE	Date	4	6
30	DCNUMCHK	Document Number Check	STR20_Document_Number	String	22	20
31	CRCRDAMT	Credit Card Amount	DLR19_RBS0_UTR$	Currency	10	19
32	CRCRDNAM	Credit Card Name	STR15	String	16	15
33	RCTNCCRD	Receipt Number Credit Card	STR20_Document_Number	String	22	20
34	CRCARDDT	Credit Card Date	DATE	Date	4	6
35	DCNUMCRD	Document Number Credit Card	STR20_Document_Number	String	22	20
36	DSCPCTAM	Discount Percent Amount	INT5_%2	Integer	2	5
37	DSCDLRAM	Discount Dollar Amount	DLR11_RBS0_UTR$	Currency	10	11
38	DISAVAMT	Discount Available Amount	DLR17_RBS0_UTR$	Currency	10	17
39	DISCAMNT	Discount Amount	DLR17_RBS0_STR$	Currency	10	17
40	DISCDATE	Discount Date	DT	Date	4	8
41	DISTKNAM	Discount Taken Amount	DLR17_RBS0_UTR$	Currency	10	17
42	DISCRTND	Discount Returned	DLR17_RBS0_STR$	Currency	10	17
43	PABillingAmount	PA Billing Amount	DLR17_RBS0_UTR$	Currency	10	17
44	TRDISAMT	Trade Discount Amount	DLR17_RBS0_UTR$	Currency	10	17
45	PA_Freight_Amount	PA Freight Amount	PA_DLR17_RBS0_STR$	Currency	10	17
46	PA_Misc_Amount	PA Misc Amount	PA_DLR17_RBS0_STR$	Currency	10	17
47	FRTTXAMT	Freight Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
48	MSCTXAMT	Misc Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
49	PATOTTAX	PA Total Tax	DLR15_RBU$2	Currency	10	15
50	PABACKBILL	PA Backout Bill Amount	DLR19_RBS0_UTR$	Currency	10	19
51	BKTFRTAM	Backout Freight Amount	DLR19_RBS0_UTR$	Currency	10	19
52	BKTMSCAM	Backout Misc Amount	DLR19_RBS0_UTR$	Currency	10	19
53	DOCAMNT	Document Amount	DLR19_RBSO_UTR$	Currency	10	19
54	DUEDATE	Due Date	DT	Date	4	8
55	APPLDAMT	Applied Amount	DLR17_RBS0_STR$	Currency	10	17
56	PALastDateApplied	PA Last Date Applied	DATE	Date	4	6
57	SLPRSNID	Salesperson ID	STR15_Salesperson_ID	String	16	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['PA Billing Header HIST'].SLPRSNID AS 'PA Billing Header HIST-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['PA Billing Header HIST'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
58	SALSTERR	Sales Territory	STR15_Sales_Territory	String	16	15
	Key to the Sales Territory Master File (RM00303). Click to show/hide SELECT ['PA Billing Header HIST'].SALSTERR AS 'PA Billing Header HIST-Sales Territory' ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN RM00303 AS ['Sales Territory Master File'] ON ['PA Billing Header HIST'].SALSTERR = ['Sales Territory Master File'].SALSTERR
59	TAXSCHID	Tax Schedule ID	STR15_Tax_Schedule_ID	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PA Billing Header HIST'].TAXSCHID AS 'PA Billing Header HIST-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PA Billing Header HIST'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
60	COMDLRAM	Commission Dollar Amount	DLR17_RBSO_STR$	Currency	10	17
61	COMAPPTO	Commission Applied To	GB	Integer	2	0
62	LNITMSEQ	Line Item Sequence	LI_Sequence_Number	Long Integer	4	10
63	CUTOFDAT	Cutoff Date	DT	Date	4	8
64	SHIPMTHD	Shipping Method	STR15_Shipping_Method	String	16	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['PA Billing Header HIST'].SHIPMTHD AS 'PA Billing Header HIST-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['PA Billing Header HIST'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
65	MSCSCHID	Misc Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PA Billing Header HIST'].MSCSCHID AS 'PA Billing Header HIST-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PA Billing Header HIST'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
66	MISCTXBL	Misc Taxable	DDL_Tax_Options	Integer	2	0
67	FRTSCHID	Freight Schedule ID	STR15_LBAU	String	16	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PA Billing Header HIST'].FRTSCHID AS 'PA Billing Header HIST-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PA Billing Header HIST'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
68	FRGTTXBL	Freight Taxable	DDL_Tax_Options	Integer	2	0
69	PARetentionFeeAmount	PA Retention Fee Amount	PA_DLR17_RBS0_STR$	Currency	10	17
70	PARetainer_Fee_Amount	PA Retainer Fee Amount	PA_DLR17_RBS0_STR$	Currency	10	17
71	PAtotbillings	PA Total Billings	DLR17_RBS0_UTR$	Currency	10	17
72	PAlastprtby	PA Last Printed By	STR15_User_ID	String	16	15
73	PAlastprtdate	PA Last Printed Date	DATE	Date	4	6
74	ORCASAMT	Originating Cash Amount	DLR19_RBSO_UTR$	Currency	10	19
75	ORCHKAMT	Originating Check Amount	DLR19_RBSO_UTR$	Currency	10	19
76	ORCCDAMT	Originating Credit Card Amount	DLR19_RBSO_UTR$	Currency	10	19
77	ORDDLRAT	Originating Discount Dollar Amount	DLR11_RBS0_UTR$	Currency	10	11
78	ORDAVAMT	Originating Discount Available Amount	DLR17_RBS0_UTR$	Currency	10	17
79	ORTDISAM	Originating Trade Discount Amount	DLR17_RBS0_UTR$	Currency	10	17
80	ORFRTTAX	Originating Freight Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
81	ORMSCTAX	Originating Misc Tax Amount	DLR19_RBSO_UTR$	Currency	10	19
82	ORBKTFRT	Originating Backout Freight Amount	DLR19_RBS0_UTR$	Currency	10	19
83	ORBKTMSC	Originating Backout Misc Amount	DLR19_RBS0_UTR$	Currency	10	19
84	ORDOCAMT	Originating Document Amount	DLR17_RBS0_STR$	Currency	10	17
85	ORAPPAMT	Originating Applied Amount	DLR17_RBS0_STR$	Currency	10	17
86	ORCOMAMT	Originating Commission Dollar Amount	DLR17_RBSO_STR$	Currency	10	17
87	PAOrigBillAmount	PA Originating Billing Amount	DLR17_RBSO_STR$	Currency	10	17
88	PAOrigFreightAmt	PA Originating Freight Amount	DLR17_RBSO_STR$	Currency	10	17
89	PAOrigMiscAmt	PA Originating Misc Amount	DLR17_RBSO_STR$	Currency	10	17
90	PAOrigTotalTaxAmt	PA Originating Total Tax	DLR17_RBSO_STR$	Currency	10	17
91	PAOrigBackoutBillAmt	PA Originating Backout Bill Amt	DLR17_RBS0_STR$	Currency	10	17
92	PAOrigRetentionFeeAmt	PA Originating Retention Fee Amt	DLR17_RBS0_STR$	Currency	10	17
93	PAOrigRetainerFeeAmt	PA Originating Retainer Fee Amt	DLR17_RBS0_STR$	Currency	10	17
94	PAOrigTotalBilings	PA Originating Total Billings	DLR17_RBS0_STR$	Currency	10	17
95	PAOrigDiscTakenAmt	PA Originating Discount Taken Amt	DLR17_RBS0_STR$	Currency	10	17
96	PAOrigDiscRetAmt	PA Originating Discount Returned Amt	DLR17_RBS0_STR$	Currency	10	17
97	CURRNIDX	Currency Index	INT3	Integer	2	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PA Billing Header HIST'].CURRNIDX AS 'PA Billing Header HIST-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PA Billing Header HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX
98	RATETPID	Rate Type ID	STR15_Rate_Type_ID	String	16	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['PA Billing Header HIST'].RATETPID AS 'PA Billing Header HIST-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['PA Billing Header HIST'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
99	EXGTBLID	Exchange Table ID	STR15_Exchange_Table_ID	String	16	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['PA Billing Header HIST'].EXGTBLID AS 'PA Billing Header HIST-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM PA33100 AS ['PA Billing Header HIST'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['PA Billing Header HIST'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
100	XCHGRATE	Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
101	EXCHDATE	Exchange Date	DT_Date	Date	4	6
102	TIME1	Time	TM6	Time	4	6
103	RTCLCMTD	Rate Calculation Method	GB	Integer	2	0
104	DENXRATE	Denomination Exchange Rate	DLR14_Exchange_Rate	Currency (Variable)	10	14
105	MCTRXSTT	MC Transaction State	INT1	Integer	2	1
106	PAPostoDynRM	PA Post to Dyn Receivables Mgmt	PA_CB_Post_RM	Boolean	2	0
107	Tax_Date	Tax Date	DT	Date	4	8
108	PA_Third_Party_CB	PA Third Party CB	CB	Boolean	2	0
109	BCKTXAMT	Backout Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
110	OBTAXAMT	Originating Backout Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
111	BackoutTradeDiscTax	Backout Trade Discount Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
112	OrigBackoutTradeDiscTax	Originating Backout Trade Discount Tax Amount	DLR17_RBS0_UTR$	Currency	10	17
113	PA_Backout_Retention_Tax	PA Backout Retention Tax Amount	PA_DLR17_RBS0_STR$	Currency	10	17
114	PA_OrigBackRetentionTax	PA Originating Backout Retention Tax Amount	PA_DLR17_RBS0_STR$	Currency	10	17
115	DEX_ROW_ID		int	int	10	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurve Products Project Accounting (258)ProjectPA Billing Header HIST (PA33100)

Leave a Reply Cancel reply