AP_Vendor1099Payments AP Vendor 1099 Payments Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_Vendor1099Payments_bus,AP_ARClearingRegister_upd,AP_CheckRegister_upd,AP_ManualCheckRegiste SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_Vendor1099Payments.M4T"
KPRIMARY: APDivisionNo+VendorNo+FormType1099+CalendarYr+BoxID KCALENDARYR: CalendarYr(d)+APDivisionNo+VendorNo+FormType1099+BoxID
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {APR$(1,2)} 2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {APR$(3,7)} 3 FormType1099. . . . . . . . . 1 SYY 1099 Form Type. . . . . . . . . DfltVal:M Valid:M,I,D Notes: {APR$(10,1)}M=Miscellaneous, I=Interest, D=Dividend 4 CalendarYr. . . . . . . . . . 4 SNY Calendar Year . . . . . . . . .YEAR Mask:0000 5 BoxID . . . . . . . . . . . . 3 SNN Box ID. . . . . . . . . . . . . 6 BoxText . . . . . . . . . . . 15 SNN Text For Text Boxes . . . . . . 7 BoxAmt. . . . . . . . . . . . 14.2 NNN Box Amount. . . . . . . . . . . ChngTag:Sum 8 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y ChngTag:Max Notes: YYYYMMDD 9 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y ChngTag:CopyMax/D ateUpdated$ 10 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 ChngTag:CopyMax/DateUpdated$